Catalog Search Results
Author
Pub. Date
2022.
Language
English
Description
Discover how to use Excel Solver to find optimal solutions to problems that range from simple to complex.
You can use Excel's Solver function to find optimal solutions to a wide range of problems, from simple to complex. In this course, Excel power user Curt Frye shows you how, with a wide range of potential challenges. Curt explains the basics of working with Solver and gives you a chance to create a Solver model. He steps through how to tune investment...
Author
Pub. Date
2019.
Language
English
Description
Learn how to analyze and display data. Discover how to install or connect to Qlik Sense, import and summarize data, create and manipulate data visualizations, and create dashboards.
Qlik Sense is a cloud-based data analytics solution that helps businesses gain valuable insights into their data. In this course, learn how to analyze and display data using this powerful platform. Instructor Curt Frye shows how to install or connect to Qlik Sense, import...
Author
Pub. Date
2021.
Language
English
Description
Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel.
Many Excel users aren’t sure how to use PivotTables. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates...
Author
Pub. Date
2023.
Language
English
Description
Learn how to use MATLAB for numerical analysis, data modeling, and data visualization.
Learn how to analyze data using one of the most powerful statistical software packages available. MATLAB is a highly useful tool for complex computation, as it allows high-order calculations and analysis in matrices. In fact, it treats all of its data as vectors and matrices, so the course starts with a basic linear algebra tutorial outside of the program before...
Author
Pub. Date
2019.
Language
English
Description
Discover how to use Excel to create a balanced scorecard to measure business performance based on financial, process, customer, and learning and growth metrics.
Discover how to use Excel to create a balanced scorecard to measure business performance based on data available throughout your organization. This course shows intermediate Excel users how to capture metrics related to the financial, process, customer, and learning and growth aspects of...
Author
Pub. Date
2017.
Language
English
Description
Discover how to create useful and powerful formulas in Tableau 10, the popular analytics and visualization tool.
Tableau 10—the popular analytics and visualization tool—provides you with the ability to create powerful calculations. In this course, learn how to leverage this aspect of the platform, and start creating useful and powerful formulas in Tableau Desktop. Instructor Curt Frye begins by going into data types, conversions, and function...
Author
Pub. Date
2017.
Language
English
Description
Explore techniques for analyzing a series of business scenarios using the flexible and powerful capabilities built into Excel.
A multitude of factors can affect the trajectory of your business. Learning how to document, summarize, and present projected business scenarios can help provide a basis for insightful business analysis, and help you evaluate the impact of various choices on your organization. In this course, explore techniques for analyzing...
Author
Pub. Date
2018.
Language
English
Description
Learn how to use MATLAB 2018 for numerical analysis, data modeling, and data visualization.
Learn how to analyze data using one of the most powerful statistical software packages available: MATLAB 2018. MATLAB is a highly useful tool for complex computation as it allows high-order calculations and analysis in matrices. In fact, it treats all of its data as vectors and matrices, so the course starts with a basic linear algebra tutorial outside of...
Author
Pub. Date
2019.
Language
English
Description
Learn to automate routine tasks and customize the functionality of Excel features with this crash course in Visual Basic for Applications (VBA).
The Visual Basic for Applications (VBA) programming language allows you to automate routine tasks in Excel—and it's not as hard to learn as most people think. In this course, Excel expert Curt Frye offers a crash course on VBA, sharing techniques that can help users of Excel 2007 or later get more out...
Author
Pub. Date
2022.
Language
English
Description
Learn to use Excel's LAMBDA function to create your own custom functions.
Discover how to create your own custom Excel functions with the LAMBDA function. Instructor Curt Frye begins with a brief history of custom functions in Excel, then explains the structure of the Excel formula language. Next, Curt shows you how to create a LAMBDA and define it as a custom function in Excel’s Name Manager. He also highlights how to manage loops and conditional...
Author
Pub. Date
2016.
Language
English
Description
Learn everything you need to know to analyze and display data using Tableau Desktop—and make better, more data-driven decisions for your company.
Tableau is the widely used data analytics and visualization tool that many consider indispensable for data-science-related work. Its drag-and-drop interface makes it easy to sort, compare, and analyze data from multiple sources, including Excel, SQL Server, and cloud-based data repositories. Tableau 10:...
Author
Pub. Date
2017.
Language
English
Description
Get started with machine learning. Learn how to separate training data from test data, prepare data for machine learning, perform supervised machine learning tasks, and more.
Learn how to analyze data using the machine learning capabilities built into Mathematica 11. In this course, Curt Frye provides an overview of machine learning tasks, explains how to separate training data from test data, and shows how to import data from a file. He also demonstrates...
Author
Pub. Date
2019.
Language
English
Description
Learn how to use Excel and VBA for business process modeling. Find out how to create and run simulations for customer flow, queuing, and manufacturing.
Excel power users: Learn how to use Excel and Visual Basic for Applications (VBA) to create and run simulations of business processes for customer flow, queuing, and manufacturing. VBA exponentially extends the power of Excel, allowing you to control process flow and logic and add custom classes and...
Author
Pub. Date
2020.
Language
English
Description
Find out how to build value stream maps in Excel and PowerPoint to analyze and visualize business processes.
Value stream mapping is a method for documenting business processes, allowing project managers and analysts to analyze the different states and identify areas of improvement. This course shows how to create value stream maps using Excel and PowerPoint. Learn how to document two real-world processes—a manufacturing process and a service process—by...
Author
Pub. Date
2023.
Language
English
Description
Learn what you need to know to analyze and display data using Tableau 2023. Discover how to leverage the software to make smarter, more data-driven decisions.
Tableau is a powerful and versatile data analytics and visualization tool that many consider indispensable for data science work. Its drag-and-drop interface makes it easy to sort, compare, and analyze data from multiple sources, including Excel, SQL Server, and cloud-based data repositories....
Author
Pub. Date
2021.
Language
English
Description
Master the essential tasks in the Mac version of Excel for Office 365. Learn how to manage workbooks, use core functions and formulas, create charts, and much more.
Excel for Mac is a powerful tool, but it can be intimidating for new users who either don't know where to start or don't know how to proceed beyond the most basic tasks. In this course, learn how to master the essential tasks in the Mac version of Excel for Office 365. Excel expert Curt...
Didn't find it?
Can't find what you are looking for? Try our Purchase Suggestion Service. Submit Request